Create a Value Column

A Lookup always has one or more Value columns. These columns represent the information that is returned (i.e., the "output') to whatever asset or feature performed the lookup.

When you create a Value column as described below, you are simply defining the name of that column. To actually populate the Value column with data, you must import a file that contains that data. See Import Lookup Data for more information on that process.

To create a Value column:

  1. Select Rules from the top navigation bar, then select Lookups from the side navigation menu. The Lookups screen is displayed.

  2. Search for and select the desired Lookup (see Search for a Lookup for more information on the available search options). The Lookup Details screen is displayed.

  3. Within the Values section, in the Label field, enter a name for the new Value column.

  4. Click Create. The Edit Lookup Value pop-up window is displayed.

  1. The Display Name field is populated with the value you entered above; optionally edit this value.

  2. The Internal Name is automatically populated based on the Display Name value. This field is not editable by default. To edit the Internal Name, check Edit Internal Name. A confirmation dialog box is displayed; click Ok. Edit the Internal Name value.

  3. Optionally, in the Default Value field, enter the default for this Value column.

  4. Optionally, in the Description field, enter a description of this item.

  5. Optionally, you can store an image within a Value column by providing the URL to the stored image. If you want the Lookup Details screen to display the image rather than the URL, check Display as Image.

  6. Click Save. The platform adds the new Value column to the Values section.

  7. Repeat the above steps as needed to define additional Value columns.